Draw attention to a peculiarity of use of aggregate functions: numerical values they return are not formatted. It becomes evident when referring to the first example with the "SUM" function:

This happens because, as a rule, the data fields return a formatted value, which is simply displayed by the "Text" object, with no changes applied. To apply external view to the "SUM" function result, let us use the values formatting tools of FastReport.

Let us select the object with the sum and call its contextual menu. The format editor is called either by using the "Formatting..." menu command, or with the help of the "DisplayFormat" property editor in the object inspector.

As you can see, the list of formatting categories and the list of the chosen category formats are placed on the left and on the right respectively. Let us select the "Number" category, and the "$1,234.50" format. At that, the formatting line corresponding to the selected format and the decimal separator character will be displayed below. The formatting line is nothing but an argument of the Delphi "Format" function, with the help of which FastReport accomplishes formatting of numbers. You can modify a formatting line as well as a separator.

After clicking the "خت" button and report constructing, you might see that the sum total in the report is correct: